Krytpo Porto Status
JY
2021-10-16
Purpose
NOTE: ORIGINAL variation with origin verbose/repeated code partially replaced with functions - key for archival purposes.
Keep track of status of krypto portfolio over time, based on transactions combined with current price data.
- Import krypto transaction data from spreadsheet.
- Download latest price data.
- Combine to calculate theoretical profit/loss trends.
- by currency
- overall portfolio
Method
- Log into crypto account.
- Download activity report.
- Go to spreadsheet in Marengo - check most recent transaction date there.
- Copy/paste new transactions from activity report.
- Copy down formulas in spreadsheet.
Bitcoin
Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
- Cdn dollar value
- Get latest price data.
- Combine with cost data.
- Calculate profit and ROI.
Ethereum
Adjusted Cost Base (Avg Cost)
Price, Costs, Profits
Cardano
Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
Polkadot
Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
Litecoin
Adjusted Cost Base (Avg Cost)
Prices, Costs, Profits
TOTALS
| date | currency | book_val | market_val | profit | roi |
|---|---|---|---|---|---|
| 2021-10-16 | BTC | $3,177 | $5,014 | 1,837 | 58% |
| 2021-10-16 | ETH | $5,954 | $17,229 | 11,275 | 189% |
| 2021-10-16 | ADA | $4,092 | $3,790 | (303) | -7% |
| 2021-10-16 | DOT | $2,535 | $3,615 | 1,081 | 43% |
| 2021-10-16 | LTC | $2,305 | $2,327 | 22 | 1% |
| date | total_invested | total_market_val | total_profit | total_roi |
|---|---|---|---|---|
| 2021-10-16 | $18,063 | $31,975 | $13,912 | 77% |